inherited frmPosStoredValueCardBill: TfrmPosStoredValueCardBill
  Caption = 'POS'#20648#20540#21345#20805#20540
  PixelsPerInch = 96
  TextHeight = 12
  inherited pnlDBCtrl: TPanel
    inherited pnlThirdtrade: TPanel
      inherited lblTTtraderid: TcxLabel
        AnchorX = 78
      end
      inherited cxLabel1: TcxLabel
        AnchorX = 262
      end
      inherited lblTTBalanceid: TcxLabel
        AnchorX = 469
      end
    end
    inherited lblName: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited DtlPageCtrl: TcxPageControl
      TabOrder = 7
    end
    inherited imgCheck: TcxImage
      TabOrder = 6
    end
    inherited lblPrinted: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited dynlblCreate_by: TcxLabel
      AnchorX = 221
    end
    inherited dynlblCheck_by: TcxLabel
      AnchorX = 429
    end
    inherited dynlblFilid: TcxLabel
      AnchorX = 88
    end
    inherited dynlblDeptid: TcxLabel
      AnchorX = 301
    end
    inherited dynlblEmpid: TcxLabel
      AnchorX = 505
    end
    inherited dynlblBKind: TcxLabel
      AnchorX = 149
    end
  end
  inherited Panel1: TPanel
    inherited labFuncName: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited labFuncDesc: TcxLabel
      Style.IsFontAssigned = True
    end
  end
  inherited pmExec: TPopupMenu
    object muPosSVCardPark: TMenuItem
      Caption = '-'
    end
    object muBatchAdd: TMenuItem
      Caption = #25209#37327#22686#21152
      OnClick = muBatchAddClick
    end
  end
  inherited cxStyleRepository1: TcxStyleRepository
    PixelsPerInch = 96
  end
  inherited qryDetail: TUniQuery
    SQLInsert.Strings = (
      'INSERT INTO tb_posstoredvaluecarddtl'
      
        '  (bid, bno, svcardid, amount, beforemoney, custom1, custom2, cu' +
        'stom3, custom4, custom5, custom6, custom7, custom8, custom9, cus' +
        'tom10, custom11, custom12, custom13, custom14, custom15, explan,' +
        ' rcvamount, discamt, filtypeid)'
      'VALUES'
      
        '  (:bid, :bno, :svcardid, :amount, :beforemoney, :custom1, :cust' +
        'om2, :custom3, :custom4, :custom5, :custom6, :custom7, :custom8,' +
        ' :custom9, :custom10, :custom11, :custom12, :custom13, :custom14' +
        ', :custom15, :explan, :rcvamount, :discamt, :filtypeid)')
    SQLDelete.Strings = (
      'DELETE FROM tb_posstoredvaluecarddtl'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLUpdate.Strings = (
      'UPDATE tb_posstoredvaluecarddtl'
      'SET'
      
        '  bid = :bid, bno = :bno, svcardid = :svcardid, amount = :amount' +
        ', beforemoney = :beforemoney, custom1 = :custom1, custom2 = :cus' +
        'tom2, custom3 = :custom3, custom4 = :custom4, custom5 = :custom5' +
        ', custom6 = :custom6, custom7 = :custom7, custom8 = :custom8, cu' +
        'stom9 = :custom9, custom10 = :custom10, custom11 = :custom11, cu' +
        'stom12 = :custom12, custom13 = :custom13, custom14 = :custom14, ' +
        'custom15 = :custom15, explan = :explan, rcvamount = :rcvamount, ' +
        'discamt = :discamt, filtypeid = :filtypeid'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLLock.Strings = (
      'SELECT * FROM tb_posstoredvaluecarddtl'
      'WITH (UPDLOCK, ROWLOCK, HOLDLOCK)'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLRefresh.Strings = (
      
        'SELECT bid, bno, svcardid, amount, beforemoney, custom1, custom2' +
        ', custom3, custom4, custom5, custom6, custom7, custom8, custom9,' +
        ' custom10, custom11, custom12, custom13, custom14, custom15, exp' +
        'lan, rcvamount, discamt, filtypeid FROM tb_posstoredvaluecarddtl'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLRecCount.Strings = (
      'SET :PCOUNT = (SELECT COUNT(*) FROM tb_posstoredvaluecarddtl'
      ')')
    Connection = MainDM.UniConn
    SQL.Strings = (
      'select * from tb_posstoredvaluecarddtl')
  end
  inherited MainDataSet: TUniQuery
    SQLInsert.Strings = (
      'INSERT INTO tb_posstoredvaluecard'
      
        '  (bid, bkind, bstate, bcode, bdate, create_by, check_by, deptid' +
        ', empid, filid, balanceid, accountid, checkno, amount, voucherid' +
        ', relationcount, create_time, update_time, remark, sflag, custom' +
        '1, custom2, custom3, custom4, custom5, custom6, custom7, custom8' +
        ', custom9, custom10, custom11, custom12, custom13, custom14, cus' +
        'tom15)'
      'VALUES'
      
        '  (:bid, :bkind, :bstate, :bcode, :bdate, :create_by, :check_by,' +
        ' :deptid, :empid, :filid, :balanceid, :accountid, :checkno, :amo' +
        'unt, :voucherid, :relationcount, :create_time, :update_time, :re' +
        'mark, :sflag, :custom1, :custom2, :custom3, :custom4, :custom5, ' +
        ':custom6, :custom7, :custom8, :custom9, :custom10, :custom11, :c' +
        'ustom12, :custom13, :custom14, :custom15)')
    SQLDelete.Strings = (
      'DELETE FROM tb_posstoredvaluecard'
      'WHERE'
      '  bid = :Old_bid')
    SQLUpdate.Strings = (
      'UPDATE tb_posstoredvaluecard'
      'SET'
      
        '  bid = :bid, bkind = :bkind, bstate = :bstate, bcode = :bcode, ' +
        'bdate = :bdate, create_by = :create_by, check_by = :check_by, de' +
        'ptid = :deptid, empid = :empid, filid = :filid, balanceid = :bal' +
        'anceid, accountid = :accountid, checkno = :checkno, amount = :am' +
        'ount, voucherid = :voucherid, relationcount = :relationcount, cr' +
        'eate_time = :create_time, update_time = :update_time, remark = :' +
        'remark, sflag = :sflag, custom1 = :custom1, custom2 = :custom2, ' +
        'custom3 = :custom3, custom4 = :custom4, custom5 = :custom5, cust' +
        'om6 = :custom6, custom7 = :custom7, custom8 = :custom8, custom9 ' +
        '= :custom9, custom10 = :custom10, custom11 = :custom11, custom12' +
        ' = :custom12, custom13 = :custom13, custom14 = :custom14, custom' +
        '15 = :custom15'
      'WHERE'
      '  bid = :Old_bid')
    SQLLock.Strings = (
      'SELECT * FROM tb_posstoredvaluecard'
      'WITH (UPDLOCK, ROWLOCK, HOLDLOCK)'
      'WHERE'
      '  bid = :Old_bid')
    SQLRefresh.Strings = (
      
        'SELECT bid, bkind, bstate, bcode, bdate, create_by, check_by, de' +
        'ptid, empid, filid, balanceid, accountid, checkno, amount, vouch' +
        'erid, relationcount, create_time, update_time, remark, sflag, cu' +
        'stom1, custom2, custom3, custom4, custom5, custom6, custom7, cus' +
        'tom8, custom9, custom10, custom11, custom12, custom13, custom14,' +
        ' custom15 FROM tb_posstoredvaluecard'
      'WHERE'
      '  bid = :Old_bid')
    SQLRecCount.Strings = (
      'SET :PCOUNT = (SELECT COUNT(*) FROM tb_posstoredvaluecard'
      ')')
    Connection = MainDM.UniConn
    SQL.Strings = (
      'select * from tb_posstoredvaluecard')
  end
end
